package com.stone.business.workcard.dao;

import java.util.List;

import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;

import frm.ssh.dao.BaseDAO;

public class WorkcardDAO extends BaseDAO {
	public List getCallBackResult() {
		return (List) this.getHibernateTemplate().execute(new HibernateCallback() {

			public Object doInHibernate(Session session) {
				SQLQuery sqlQuery = session
						.createSQLQuery("{call get_finishrate(?,?)}");
				sqlQuery.setString(0, "");
				sqlQuery.setString(1, "2012-03-01");
				
				return sqlQuery.list();
			}
		});
	}
}
